Solutions: ROW_NUMBER & RANK

Ranking Total Paper Ordered by Account

SELECT id,
       account_id,
       total,
       RANK() OVER (PARTITION BY account_id ORDER BY total DESC) AS total_rank
FROM orders

If you need a code on the https://github.com/udacity.